package com.autohome.wz.business.mallOperation.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderCommissionExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderCommissionExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrdernumIsNull() {
            addCriterion("ordernum is null");
            return (Criteria) this;
        }

        public Criteria andOrdernumIsNotNull() {
            addCriterion("ordernum is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernumEqualTo(String value) {
            addCriterion("ordernum =", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotEqualTo(String value) {
            addCriterion("ordernum <>", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumGreaterThan(String value) {
            addCriterion("ordernum >", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumGreaterThanOrEqualTo(String value) {
            addCriterion("ordernum >=", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumLessThan(String value) {
            addCriterion("ordernum <", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumLessThanOrEqualTo(String value) {
            addCriterion("ordernum <=", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumLike(String value) {
            addCriterion("ordernum like", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotLike(String value) {
            addCriterion("ordernum not like", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumIn(List<String> values) {
            addCriterion("ordernum in", values, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotIn(List<String> values) {
            addCriterion("ordernum not in", values, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumBetween(String value1, String value2) {
            addCriterion("ordernum between", value1, value2, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotBetween(String value1, String value2) {
            addCriterion("ordernum not between", value1, value2, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrderdetailIdIsNull() {
            addCriterion("orderdetail_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderdetailIdIsNotNull() {
            addCriterion("orderdetail_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderdetailIdEqualTo(Integer value) {
            addCriterion("orderdetail_id =", value, "orderdetailId");
            return (Criteria) this;
        }

        public Criteria andOrderdetailIdNotEqualTo(Integer value) {
            addCriterion("orderdetail_id <>", value, "orderdetailId");
            return (Criteria) this;
        }

        public Criteria andOrderdetailIdGreaterThan(Integer value) {
            addCriterion("orderdetail_id >", value, "orderdetailId");
            return (Criteria) this;
        }

        public Criteria andOrderdetailIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("orderdetail_id >=", value, "orderdetailId");
            return (Criteria) this;
        }

        public Criteria andOrderdetailIdLessThan(Integer value) {
            addCriterion("orderdetail_id <", value, "orderdetailId");
            return (Criteria) this;
        }

        public Criteria andOrderdetailIdLessThanOrEqualTo(Integer value) {
            addCriterion("orderdetail_id <=", value, "orderdetailId");
            return (Criteria) this;
        }

        public Criteria andOrderdetailIdIn(List<Integer> values) {
            addCriterion("orderdetail_id in", values, "orderdetailId");
            return (Criteria) this;
        }

        public Criteria andOrderdetailIdNotIn(List<Integer> values) {
            addCriterion("orderdetail_id not in", values, "orderdetailId");
            return (Criteria) this;
        }

        public Criteria andOrderdetailIdBetween(Integer value1, Integer value2) {
            addCriterion("orderdetail_id between", value1, value2, "orderdetailId");
            return (Criteria) this;
        }

        public Criteria andOrderdetailIdNotBetween(Integer value1, Integer value2) {
            addCriterion("orderdetail_id not between", value1, value2, "orderdetailId");
            return (Criteria) this;
        }

        public Criteria andBuserIdIsNull() {
            addCriterion("buser_id is null");
            return (Criteria) this;
        }

        public Criteria andBuserIdIsNotNull() {
            addCriterion("buser_id is not null");
            return (Criteria) this;
        }

        public Criteria andBuserIdEqualTo(Integer value) {
            addCriterion("buser_id =", value, "buserId");
            return (Criteria) this;
        }

        public Criteria andBuserIdNotEqualTo(Integer value) {
            addCriterion("buser_id <>", value, "buserId");
            return (Criteria) this;
        }

        public Criteria andBuserIdGreaterThan(Integer value) {
            addCriterion("buser_id >", value, "buserId");
            return (Criteria) this;
        }

        public Criteria andBuserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("buser_id >=", value, "buserId");
            return (Criteria) this;
        }

        public Criteria andBuserIdLessThan(Integer value) {
            addCriterion("buser_id <", value, "buserId");
            return (Criteria) this;
        }

        public Criteria andBuserIdLessThanOrEqualTo(Integer value) {
            addCriterion("buser_id <=", value, "buserId");
            return (Criteria) this;
        }

        public Criteria andBuserIdIn(List<Integer> values) {
            addCriterion("buser_id in", values, "buserId");
            return (Criteria) this;
        }

        public Criteria andBuserIdNotIn(List<Integer> values) {
            addCriterion("buser_id not in", values, "buserId");
            return (Criteria) this;
        }

        public Criteria andBuserIdBetween(Integer value1, Integer value2) {
            addCriterion("buser_id between", value1, value2, "buserId");
            return (Criteria) this;
        }

        public Criteria andBuserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("buser_id not between", value1, value2, "buserId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNull() {
            addCriterion("member_id is null");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNotNull() {
            addCriterion("member_id is not null");
            return (Criteria) this;
        }

        public Criteria andMemberIdEqualTo(String value) {
            addCriterion("member_id =", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotEqualTo(String value) {
            addCriterion("member_id <>", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThan(String value) {
            addCriterion("member_id >", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThanOrEqualTo(String value) {
            addCriterion("member_id >=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThan(String value) {
            addCriterion("member_id <", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThanOrEqualTo(String value) {
            addCriterion("member_id <=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLike(String value) {
            addCriterion("member_id like", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotLike(String value) {
            addCriterion("member_id not like", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIn(List<String> values) {
            addCriterion("member_id in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotIn(List<String> values) {
            addCriterion("member_id not in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdBetween(String value1, String value2) {
            addCriterion("member_id between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotBetween(String value1, String value2) {
            addCriterion("member_id not between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andPskuIdIsNull() {
            addCriterion("psku_id is null");
            return (Criteria) this;
        }

        public Criteria andPskuIdIsNotNull() {
            addCriterion("psku_id is not null");
            return (Criteria) this;
        }

        public Criteria andPskuIdEqualTo(String value) {
            addCriterion("psku_id =", value, "pskuId");
            return (Criteria) this;
        }

        public Criteria andPskuIdNotEqualTo(String value) {
            addCriterion("psku_id <>", value, "pskuId");
            return (Criteria) this;
        }

        public Criteria andPskuIdGreaterThan(String value) {
            addCriterion("psku_id >", value, "pskuId");
            return (Criteria) this;
        }

        public Criteria andPskuIdGreaterThanOrEqualTo(String value) {
            addCriterion("psku_id >=", value, "pskuId");
            return (Criteria) this;
        }

        public Criteria andPskuIdLessThan(String value) {
            addCriterion("psku_id <", value, "pskuId");
            return (Criteria) this;
        }

        public Criteria andPskuIdLessThanOrEqualTo(String value) {
            addCriterion("psku_id <=", value, "pskuId");
            return (Criteria) this;
        }

        public Criteria andPskuIdLike(String value) {
            addCriterion("psku_id like", value, "pskuId");
            return (Criteria) this;
        }

        public Criteria andPskuIdNotLike(String value) {
            addCriterion("psku_id not like", value, "pskuId");
            return (Criteria) this;
        }

        public Criteria andPskuIdIn(List<String> values) {
            addCriterion("psku_id in", values, "pskuId");
            return (Criteria) this;
        }

        public Criteria andPskuIdNotIn(List<String> values) {
            addCriterion("psku_id not in", values, "pskuId");
            return (Criteria) this;
        }

        public Criteria andPskuIdBetween(String value1, String value2) {
            addCriterion("psku_id between", value1, value2, "pskuId");
            return (Criteria) this;
        }

        public Criteria andPskuIdNotBetween(String value1, String value2) {
            addCriterion("psku_id not between", value1, value2, "pskuId");
            return (Criteria) this;
        }

        public Criteria andProdNameIsNull() {
            addCriterion("prod_name is null");
            return (Criteria) this;
        }

        public Criteria andProdNameIsNotNull() {
            addCriterion("prod_name is not null");
            return (Criteria) this;
        }

        public Criteria andProdNameEqualTo(String value) {
            addCriterion("prod_name =", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameNotEqualTo(String value) {
            addCriterion("prod_name <>", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameGreaterThan(String value) {
            addCriterion("prod_name >", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameGreaterThanOrEqualTo(String value) {
            addCriterion("prod_name >=", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameLessThan(String value) {
            addCriterion("prod_name <", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameLessThanOrEqualTo(String value) {
            addCriterion("prod_name <=", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameLike(String value) {
            addCriterion("prod_name like", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameNotLike(String value) {
            addCriterion("prod_name not like", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameIn(List<String> values) {
            addCriterion("prod_name in", values, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameNotIn(List<String> values) {
            addCriterion("prod_name not in", values, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameBetween(String value1, String value2) {
            addCriterion("prod_name between", value1, value2, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameNotBetween(String value1, String value2) {
            addCriterion("prod_name not between", value1, value2, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdPriceIsNull() {
            addCriterion("prod_price is null");
            return (Criteria) this;
        }

        public Criteria andProdPriceIsNotNull() {
            addCriterion("prod_price is not null");
            return (Criteria) this;
        }

        public Criteria andProdPriceEqualTo(BigDecimal value) {
            addCriterion("prod_price =", value, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceNotEqualTo(BigDecimal value) {
            addCriterion("prod_price <>", value, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceGreaterThan(BigDecimal value) {
            addCriterion("prod_price >", value, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_price >=", value, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceLessThan(BigDecimal value) {
            addCriterion("prod_price <", value, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_price <=", value, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceIn(List<BigDecimal> values) {
            addCriterion("prod_price in", values, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceNotIn(List<BigDecimal> values) {
            addCriterion("prod_price not in", values, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_price between", value1, value2, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_price not between", value1, value2, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andCommissionScaleIsNull() {
            addCriterion("commission_scale is null");
            return (Criteria) this;
        }

        public Criteria andCommissionScaleIsNotNull() {
            addCriterion("commission_scale is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionScaleEqualTo(BigDecimal value) {
            addCriterion("commission_scale =", value, "commissionScale");
            return (Criteria) this;
        }

        public Criteria andCommissionScaleNotEqualTo(BigDecimal value) {
            addCriterion("commission_scale <>", value, "commissionScale");
            return (Criteria) this;
        }

        public Criteria andCommissionScaleGreaterThan(BigDecimal value) {
            addCriterion("commission_scale >", value, "commissionScale");
            return (Criteria) this;
        }

        public Criteria andCommissionScaleGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("commission_scale >=", value, "commissionScale");
            return (Criteria) this;
        }

        public Criteria andCommissionScaleLessThan(BigDecimal value) {
            addCriterion("commission_scale <", value, "commissionScale");
            return (Criteria) this;
        }

        public Criteria andCommissionScaleLessThanOrEqualTo(BigDecimal value) {
            addCriterion("commission_scale <=", value, "commissionScale");
            return (Criteria) this;
        }

        public Criteria andCommissionScaleIn(List<BigDecimal> values) {
            addCriterion("commission_scale in", values, "commissionScale");
            return (Criteria) this;
        }

        public Criteria andCommissionScaleNotIn(List<BigDecimal> values) {
            addCriterion("commission_scale not in", values, "commissionScale");
            return (Criteria) this;
        }

        public Criteria andCommissionScaleBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("commission_scale between", value1, value2, "commissionScale");
            return (Criteria) this;
        }

        public Criteria andCommissionScaleNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("commission_scale not between", value1, value2, "commissionScale");
            return (Criteria) this;
        }

        public Criteria andCommissionPriceIsNull() {
            addCriterion("commission_price is null");
            return (Criteria) this;
        }

        public Criteria andCommissionPriceIsNotNull() {
            addCriterion("commission_price is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionPriceEqualTo(BigDecimal value) {
            addCriterion("commission_price =", value, "commissionPrice");
            return (Criteria) this;
        }

        public Criteria andCommissionPriceNotEqualTo(BigDecimal value) {
            addCriterion("commission_price <>", value, "commissionPrice");
            return (Criteria) this;
        }

        public Criteria andCommissionPriceGreaterThan(BigDecimal value) {
            addCriterion("commission_price >", value, "commissionPrice");
            return (Criteria) this;
        }

        public Criteria andCommissionPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("commission_price >=", value, "commissionPrice");
            return (Criteria) this;
        }

        public Criteria andCommissionPriceLessThan(BigDecimal value) {
            addCriterion("commission_price <", value, "commissionPrice");
            return (Criteria) this;
        }

        public Criteria andCommissionPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("commission_price <=", value, "commissionPrice");
            return (Criteria) this;
        }

        public Criteria andCommissionPriceIn(List<BigDecimal> values) {
            addCriterion("commission_price in", values, "commissionPrice");
            return (Criteria) this;
        }

        public Criteria andCommissionPriceNotIn(List<BigDecimal> values) {
            addCriterion("commission_price not in", values, "commissionPrice");
            return (Criteria) this;
        }

        public Criteria andCommissionPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("commission_price between", value1, value2, "commissionPrice");
            return (Criteria) this;
        }

        public Criteria andCommissionPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("commission_price not between", value1, value2, "commissionPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceIsNull() {
            addCriterion("tax_price is null");
            return (Criteria) this;
        }

        public Criteria andTaxPriceIsNotNull() {
            addCriterion("tax_price is not null");
            return (Criteria) this;
        }

        public Criteria andTaxPriceEqualTo(BigDecimal value) {
            addCriterion("tax_price =", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceNotEqualTo(BigDecimal value) {
            addCriterion("tax_price <>", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceGreaterThan(BigDecimal value) {
            addCriterion("tax_price >", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("tax_price >=", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceLessThan(BigDecimal value) {
            addCriterion("tax_price <", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("tax_price <=", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceIn(List<BigDecimal> values) {
            addCriterion("tax_price in", values, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceNotIn(List<BigDecimal> values) {
            addCriterion("tax_price not in", values, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tax_price between", value1, value2, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tax_price not between", value1, value2, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andCommissionStatusIsNull() {
            addCriterion("commission_status is null");
            return (Criteria) this;
        }

        public Criteria andCommissionStatusIsNotNull() {
            addCriterion("commission_status is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionStatusEqualTo(Integer value) {
            addCriterion("commission_status =", value, "commissionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionStatusNotEqualTo(Integer value) {
            addCriterion("commission_status <>", value, "commissionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionStatusGreaterThan(Integer value) {
            addCriterion("commission_status >", value, "commissionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("commission_status >=", value, "commissionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionStatusLessThan(Integer value) {
            addCriterion("commission_status <", value, "commissionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionStatusLessThanOrEqualTo(Integer value) {
            addCriterion("commission_status <=", value, "commissionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionStatusIn(List<Integer> values) {
            addCriterion("commission_status in", values, "commissionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionStatusNotIn(List<Integer> values) {
            addCriterion("commission_status not in", values, "commissionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionStatusBetween(Integer value1, Integer value2) {
            addCriterion("commission_status between", value1, value2, "commissionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("commission_status not between", value1, value2, "commissionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeIsNull() {
            addCriterion("commission_type is null");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeIsNotNull() {
            addCriterion("commission_type is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeEqualTo(Integer value) {
            addCriterion("commission_type =", value, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeNotEqualTo(Integer value) {
            addCriterion("commission_type <>", value, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeGreaterThan(Integer value) {
            addCriterion("commission_type >", value, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("commission_type >=", value, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeLessThan(Integer value) {
            addCriterion("commission_type <", value, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeLessThanOrEqualTo(Integer value) {
            addCriterion("commission_type <=", value, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeIn(List<Integer> values) {
            addCriterion("commission_type in", values, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeNotIn(List<Integer> values) {
            addCriterion("commission_type not in", values, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeBetween(Integer value1, Integer value2) {
            addCriterion("commission_type between", value1, value2, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("commission_type not between", value1, value2, "commissionType");
            return (Criteria) this;
        }

        public Criteria andSyncStatusIsNull() {
            addCriterion("sync_status is null");
            return (Criteria) this;
        }

        public Criteria andSyncStatusIsNotNull() {
            addCriterion("sync_status is not null");
            return (Criteria) this;
        }

        public Criteria andSyncStatusEqualTo(Integer value) {
            addCriterion("sync_status =", value, "syncStatus");
            return (Criteria) this;
        }

        public Criteria andSyncStatusNotEqualTo(Integer value) {
            addCriterion("sync_status <>", value, "syncStatus");
            return (Criteria) this;
        }

        public Criteria andSyncStatusGreaterThan(Integer value) {
            addCriterion("sync_status >", value, "syncStatus");
            return (Criteria) this;
        }

        public Criteria andSyncStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("sync_status >=", value, "syncStatus");
            return (Criteria) this;
        }

        public Criteria andSyncStatusLessThan(Integer value) {
            addCriterion("sync_status <", value, "syncStatus");
            return (Criteria) this;
        }

        public Criteria andSyncStatusLessThanOrEqualTo(Integer value) {
            addCriterion("sync_status <=", value, "syncStatus");
            return (Criteria) this;
        }

        public Criteria andSyncStatusIn(List<Integer> values) {
            addCriterion("sync_status in", values, "syncStatus");
            return (Criteria) this;
        }

        public Criteria andSyncStatusNotIn(List<Integer> values) {
            addCriterion("sync_status not in", values, "syncStatus");
            return (Criteria) this;
        }

        public Criteria andSyncStatusBetween(Integer value1, Integer value2) {
            addCriterion("sync_status between", value1, value2, "syncStatus");
            return (Criteria) this;
        }

        public Criteria andSyncStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("sync_status not between", value1, value2, "syncStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDateIsNull() {
            addCriterion("commission_date is null");
            return (Criteria) this;
        }

        public Criteria andCommissionDateIsNotNull() {
            addCriterion("commission_date is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionDateEqualTo(Date value) {
            addCriterion("commission_date =", value, "commissionDate");
            return (Criteria) this;
        }

        public Criteria andCommissionDateNotEqualTo(Date value) {
            addCriterion("commission_date <>", value, "commissionDate");
            return (Criteria) this;
        }

        public Criteria andCommissionDateGreaterThan(Date value) {
            addCriterion("commission_date >", value, "commissionDate");
            return (Criteria) this;
        }

        public Criteria andCommissionDateGreaterThanOrEqualTo(Date value) {
            addCriterion("commission_date >=", value, "commissionDate");
            return (Criteria) this;
        }

        public Criteria andCommissionDateLessThan(Date value) {
            addCriterion("commission_date <", value, "commissionDate");
            return (Criteria) this;
        }

        public Criteria andCommissionDateLessThanOrEqualTo(Date value) {
            addCriterion("commission_date <=", value, "commissionDate");
            return (Criteria) this;
        }

        public Criteria andCommissionDateIn(List<Date> values) {
            addCriterion("commission_date in", values, "commissionDate");
            return (Criteria) this;
        }

        public Criteria andCommissionDateNotIn(List<Date> values) {
            addCriterion("commission_date not in", values, "commissionDate");
            return (Criteria) this;
        }

        public Criteria andCommissionDateBetween(Date value1, Date value2) {
            addCriterion("commission_date between", value1, value2, "commissionDate");
            return (Criteria) this;
        }

        public Criteria andCommissionDateNotBetween(Date value1, Date value2) {
            addCriterion("commission_date not between", value1, value2, "commissionDate");
            return (Criteria) this;
        }

        public Criteria andSellerIdIsNull() {
            addCriterion("seller_id is null");
            return (Criteria) this;
        }

        public Criteria andSellerIdIsNotNull() {
            addCriterion("seller_id is not null");
            return (Criteria) this;
        }

        public Criteria andSellerIdEqualTo(Integer value) {
            addCriterion("seller_id =", value, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdNotEqualTo(Integer value) {
            addCriterion("seller_id <>", value, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdGreaterThan(Integer value) {
            addCriterion("seller_id >", value, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("seller_id >=", value, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdLessThan(Integer value) {
            addCriterion("seller_id <", value, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdLessThanOrEqualTo(Integer value) {
            addCriterion("seller_id <=", value, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdIn(List<Integer> values) {
            addCriterion("seller_id in", values, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdNotIn(List<Integer> values) {
            addCriterion("seller_id not in", values, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdBetween(Integer value1, Integer value2) {
            addCriterion("seller_id between", value1, value2, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdNotBetween(Integer value1, Integer value2) {
            addCriterion("seller_id not between", value1, value2, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerNameIsNull() {
            addCriterion("seller_name is null");
            return (Criteria) this;
        }

        public Criteria andSellerNameIsNotNull() {
            addCriterion("seller_name is not null");
            return (Criteria) this;
        }

        public Criteria andSellerNameEqualTo(String value) {
            addCriterion("seller_name =", value, "sellerName");
            return (Criteria) this;
        }

        public Criteria andSellerNameNotEqualTo(String value) {
            addCriterion("seller_name <>", value, "sellerName");
            return (Criteria) this;
        }

        public Criteria andSellerNameGreaterThan(String value) {
            addCriterion("seller_name >", value, "sellerName");
            return (Criteria) this;
        }

        public Criteria andSellerNameGreaterThanOrEqualTo(String value) {
            addCriterion("seller_name >=", value, "sellerName");
            return (Criteria) this;
        }

        public Criteria andSellerNameLessThan(String value) {
            addCriterion("seller_name <", value, "sellerName");
            return (Criteria) this;
        }

        public Criteria andSellerNameLessThanOrEqualTo(String value) {
            addCriterion("seller_name <=", value, "sellerName");
            return (Criteria) this;
        }

        public Criteria andSellerNameLike(String value) {
            addCriterion("seller_name like", value, "sellerName");
            return (Criteria) this;
        }

        public Criteria andSellerNameNotLike(String value) {
            addCriterion("seller_name not like", value, "sellerName");
            return (Criteria) this;
        }

        public Criteria andSellerNameIn(List<String> values) {
            addCriterion("seller_name in", values, "sellerName");
            return (Criteria) this;
        }

        public Criteria andSellerNameNotIn(List<String> values) {
            addCriterion("seller_name not in", values, "sellerName");
            return (Criteria) this;
        }

        public Criteria andSellerNameBetween(String value1, String value2) {
            addCriterion("seller_name between", value1, value2, "sellerName");
            return (Criteria) this;
        }

        public Criteria andSellerNameNotBetween(String value1, String value2) {
            addCriterion("seller_name not between", value1, value2, "sellerName");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createtime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createtime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createtime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createtime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createtime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createtime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createtime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createtime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createtime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createtime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createtime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createtime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("updatetime is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("updatetime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterion("updatetime =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterion("updatetime <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterion("updatetime >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("updatetime >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterion("updatetime <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterion("updatetime <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterion("updatetime in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterion("updatetime not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterion("updatetime between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterion("updatetime not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andPlatformIdIsNull() {
            addCriterion("platform_id is null");
            return (Criteria) this;
        }

        public Criteria andPlatformIdIsNotNull() {
            addCriterion("platform_id is not null");
            return (Criteria) this;
        }

        public Criteria andPlatformIdEqualTo(String value) {
            addCriterion("platform_id =", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdNotEqualTo(String value) {
            addCriterion("platform_id <>", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdGreaterThan(String value) {
            addCriterion("platform_id >", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdGreaterThanOrEqualTo(String value) {
            addCriterion("platform_id >=", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdLessThan(String value) {
            addCriterion("platform_id <", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdLessThanOrEqualTo(String value) {
            addCriterion("platform_id <=", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdLike(String value) {
            addCriterion("platform_id like", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdNotLike(String value) {
            addCriterion("platform_id not like", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdIn(List<String> values) {
            addCriterion("platform_id in", values, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdNotIn(List<String> values) {
            addCriterion("platform_id not in", values, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdBetween(String value1, String value2) {
            addCriterion("platform_id between", value1, value2, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdNotBetween(String value1, String value2) {
            addCriterion("platform_id not between", value1, value2, "platformId");
            return (Criteria) this;
        }

        public Criteria andExtInfoIsNull() {
            addCriterion("ext_info is null");
            return (Criteria) this;
        }

        public Criteria andExtInfoIsNotNull() {
            addCriterion("ext_info is not null");
            return (Criteria) this;
        }

        public Criteria andExtInfoEqualTo(String value) {
            addCriterion("ext_info =", value, "extInfo");
            return (Criteria) this;
        }

        public Criteria andExtInfoNotEqualTo(String value) {
            addCriterion("ext_info <>", value, "extInfo");
            return (Criteria) this;
        }

        public Criteria andExtInfoGreaterThan(String value) {
            addCriterion("ext_info >", value, "extInfo");
            return (Criteria) this;
        }

        public Criteria andExtInfoGreaterThanOrEqualTo(String value) {
            addCriterion("ext_info >=", value, "extInfo");
            return (Criteria) this;
        }

        public Criteria andExtInfoLessThan(String value) {
            addCriterion("ext_info <", value, "extInfo");
            return (Criteria) this;
        }

        public Criteria andExtInfoLessThanOrEqualTo(String value) {
            addCriterion("ext_info <=", value, "extInfo");
            return (Criteria) this;
        }

        public Criteria andExtInfoLike(String value) {
            addCriterion("ext_info like", value, "extInfo");
            return (Criteria) this;
        }

        public Criteria andExtInfoNotLike(String value) {
            addCriterion("ext_info not like", value, "extInfo");
            return (Criteria) this;
        }

        public Criteria andExtInfoIn(List<String> values) {
            addCriterion("ext_info in", values, "extInfo");
            return (Criteria) this;
        }

        public Criteria andExtInfoNotIn(List<String> values) {
            addCriterion("ext_info not in", values, "extInfo");
            return (Criteria) this;
        }

        public Criteria andExtInfoBetween(String value1, String value2) {
            addCriterion("ext_info between", value1, value2, "extInfo");
            return (Criteria) this;
        }

        public Criteria andExtInfoNotBetween(String value1, String value2) {
            addCriterion("ext_info not between", value1, value2, "extInfo");
            return (Criteria) this;
        }

        public Criteria andCuserIdIsNull() {
            addCriterion("cuser_id is null");
            return (Criteria) this;
        }

        public Criteria andCuserIdIsNotNull() {
            addCriterion("cuser_id is not null");
            return (Criteria) this;
        }

        public Criteria andCuserIdEqualTo(Integer value) {
            addCriterion("cuser_id =", value, "cuserId");
            return (Criteria) this;
        }

        public Criteria andCuserIdNotEqualTo(Integer value) {
            addCriterion("cuser_id <>", value, "cuserId");
            return (Criteria) this;
        }

        public Criteria andCuserIdGreaterThan(Integer value) {
            addCriterion("cuser_id >", value, "cuserId");
            return (Criteria) this;
        }

        public Criteria andCuserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("cuser_id >=", value, "cuserId");
            return (Criteria) this;
        }

        public Criteria andCuserIdLessThan(Integer value) {
            addCriterion("cuser_id <", value, "cuserId");
            return (Criteria) this;
        }

        public Criteria andCuserIdLessThanOrEqualTo(Integer value) {
            addCriterion("cuser_id <=", value, "cuserId");
            return (Criteria) this;
        }

        public Criteria andCuserIdIn(List<Integer> values) {
            addCriterion("cuser_id in", values, "cuserId");
            return (Criteria) this;
        }

        public Criteria andCuserIdNotIn(List<Integer> values) {
            addCriterion("cuser_id not in", values, "cuserId");
            return (Criteria) this;
        }

        public Criteria andCuserIdBetween(Integer value1, Integer value2) {
            addCriterion("cuser_id between", value1, value2, "cuserId");
            return (Criteria) this;
        }

        public Criteria andCuserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("cuser_id not between", value1, value2, "cuserId");
            return (Criteria) this;
        }

        public Criteria andRecycleIsNull() {
            addCriterion("recycle is null");
            return (Criteria) this;
        }

        public Criteria andRecycleIsNotNull() {
            addCriterion("recycle is not null");
            return (Criteria) this;
        }

        public Criteria andRecycleEqualTo(String value) {
            addCriterion("recycle =", value, "recycle");
            return (Criteria) this;
        }

        public Criteria andRecycleNotEqualTo(String value) {
            addCriterion("recycle <>", value, "recycle");
            return (Criteria) this;
        }

        public Criteria andRecycleGreaterThan(String value) {
            addCriterion("recycle >", value, "recycle");
            return (Criteria) this;
        }

        public Criteria andRecycleGreaterThanOrEqualTo(String value) {
            addCriterion("recycle >=", value, "recycle");
            return (Criteria) this;
        }

        public Criteria andRecycleLessThan(String value) {
            addCriterion("recycle <", value, "recycle");
            return (Criteria) this;
        }

        public Criteria andRecycleLessThanOrEqualTo(String value) {
            addCriterion("recycle <=", value, "recycle");
            return (Criteria) this;
        }

        public Criteria andRecycleLike(String value) {
            addCriterion("recycle like", value, "recycle");
            return (Criteria) this;
        }

        public Criteria andRecycleNotLike(String value) {
            addCriterion("recycle not like", value, "recycle");
            return (Criteria) this;
        }

        public Criteria andRecycleIn(List<String> values) {
            addCriterion("recycle in", values, "recycle");
            return (Criteria) this;
        }

        public Criteria andRecycleNotIn(List<String> values) {
            addCriterion("recycle not in", values, "recycle");
            return (Criteria) this;
        }

        public Criteria andRecycleBetween(String value1, String value2) {
            addCriterion("recycle between", value1, value2, "recycle");
            return (Criteria) this;
        }

        public Criteria andRecycleNotBetween(String value1, String value2) {
            addCriterion("recycle not between", value1, value2, "recycle");
            return (Criteria) this;
        }

        public Criteria andItemIdIsNull() {
            addCriterion("item_id is null");
            return (Criteria) this;
        }

        public Criteria andItemIdIsNotNull() {
            addCriterion("item_id is not null");
            return (Criteria) this;
        }

        public Criteria andItemIdEqualTo(Integer value) {
            addCriterion("item_id =", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotEqualTo(Integer value) {
            addCriterion("item_id <>", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdGreaterThan(Integer value) {
            addCriterion("item_id >", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("item_id >=", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdLessThan(Integer value) {
            addCriterion("item_id <", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdLessThanOrEqualTo(Integer value) {
            addCriterion("item_id <=", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdIn(List<Integer> values) {
            addCriterion("item_id in", values, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotIn(List<Integer> values) {
            addCriterion("item_id not in", values, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdBetween(Integer value1, Integer value2) {
            addCriterion("item_id between", value1, value2, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotBetween(Integer value1, Integer value2) {
            addCriterion("item_id not between", value1, value2, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemSkuIdIsNull() {
            addCriterion("item_sku_id is null");
            return (Criteria) this;
        }

        public Criteria andItemSkuIdIsNotNull() {
            addCriterion("item_sku_id is not null");
            return (Criteria) this;
        }

        public Criteria andItemSkuIdEqualTo(Integer value) {
            addCriterion("item_sku_id =", value, "itemSkuId");
            return (Criteria) this;
        }

        public Criteria andItemSkuIdNotEqualTo(Integer value) {
            addCriterion("item_sku_id <>", value, "itemSkuId");
            return (Criteria) this;
        }

        public Criteria andItemSkuIdGreaterThan(Integer value) {
            addCriterion("item_sku_id >", value, "itemSkuId");
            return (Criteria) this;
        }

        public Criteria andItemSkuIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("item_sku_id >=", value, "itemSkuId");
            return (Criteria) this;
        }

        public Criteria andItemSkuIdLessThan(Integer value) {
            addCriterion("item_sku_id <", value, "itemSkuId");
            return (Criteria) this;
        }

        public Criteria andItemSkuIdLessThanOrEqualTo(Integer value) {
            addCriterion("item_sku_id <=", value, "itemSkuId");
            return (Criteria) this;
        }

        public Criteria andItemSkuIdIn(List<Integer> values) {
            addCriterion("item_sku_id in", values, "itemSkuId");
            return (Criteria) this;
        }

        public Criteria andItemSkuIdNotIn(List<Integer> values) {
            addCriterion("item_sku_id not in", values, "itemSkuId");
            return (Criteria) this;
        }

        public Criteria andItemSkuIdBetween(Integer value1, Integer value2) {
            addCriterion("item_sku_id between", value1, value2, "itemSkuId");
            return (Criteria) this;
        }

        public Criteria andItemSkuIdNotBetween(Integer value1, Integer value2) {
            addCriterion("item_sku_id not between", value1, value2, "itemSkuId");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("source is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("source is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(String value) {
            addCriterion("source =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(String value) {
            addCriterion("source <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(String value) {
            addCriterion("source >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(String value) {
            addCriterion("source >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(String value) {
            addCriterion("source <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(String value) {
            addCriterion("source <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLike(String value) {
            addCriterion("source like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotLike(String value) {
            addCriterion("source not like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<String> values) {
            addCriterion("source in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<String> values) {
            addCriterion("source not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(String value1, String value2) {
            addCriterion("source between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(String value1, String value2) {
            addCriterion("source not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andBusinessIdIsNull() {
            addCriterion("business_id is null");
            return (Criteria) this;
        }

        public Criteria andBusinessIdIsNotNull() {
            addCriterion("business_id is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessIdEqualTo(String value) {
            addCriterion("business_id =", value, "businessId");
            return (Criteria) this;
        }

        public Criteria andBusinessIdNotEqualTo(String value) {
            addCriterion("business_id <>", value, "businessId");
            return (Criteria) this;
        }

        public Criteria andBusinessIdGreaterThan(String value) {
            addCriterion("business_id >", value, "businessId");
            return (Criteria) this;
        }

        public Criteria andBusinessIdGreaterThanOrEqualTo(String value) {
            addCriterion("business_id >=", value, "businessId");
            return (Criteria) this;
        }

        public Criteria andBusinessIdLessThan(String value) {
            addCriterion("business_id <", value, "businessId");
            return (Criteria) this;
        }

        public Criteria andBusinessIdLessThanOrEqualTo(String value) {
            addCriterion("business_id <=", value, "businessId");
            return (Criteria) this;
        }

        public Criteria andBusinessIdLike(String value) {
            addCriterion("business_id like", value, "businessId");
            return (Criteria) this;
        }

        public Criteria andBusinessIdNotLike(String value) {
            addCriterion("business_id not like", value, "businessId");
            return (Criteria) this;
        }

        public Criteria andBusinessIdIn(List<String> values) {
            addCriterion("business_id in", values, "businessId");
            return (Criteria) this;
        }

        public Criteria andBusinessIdNotIn(List<String> values) {
            addCriterion("business_id not in", values, "businessId");
            return (Criteria) this;
        }

        public Criteria andBusinessIdBetween(String value1, String value2) {
            addCriterion("business_id between", value1, value2, "businessId");
            return (Criteria) this;
        }

        public Criteria andBusinessIdNotBetween(String value1, String value2) {
            addCriterion("business_id not between", value1, value2, "businessId");
            return (Criteria) this;
        }

        public Criteria andCreatedStimeIsNull() {
            addCriterion("Created_STime is null");
            return (Criteria) this;
        }

        public Criteria andCreatedStimeIsNotNull() {
            addCriterion("Created_STime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedStimeEqualTo(Date value) {
            addCriterion("Created_STime =", value, "createdStime");
            return (Criteria) this;
        }

        public Criteria andCreatedStimeNotEqualTo(Date value) {
            addCriterion("Created_STime <>", value, "createdStime");
            return (Criteria) this;
        }

        public Criteria andCreatedStimeGreaterThan(Date value) {
            addCriterion("Created_STime >", value, "createdStime");
            return (Criteria) this;
        }

        public Criteria andCreatedStimeGreaterThanOrEqualTo(Date value) {
            addCriterion("Created_STime >=", value, "createdStime");
            return (Criteria) this;
        }

        public Criteria andCreatedStimeLessThan(Date value) {
            addCriterion("Created_STime <", value, "createdStime");
            return (Criteria) this;
        }

        public Criteria andCreatedStimeLessThanOrEqualTo(Date value) {
            addCriterion("Created_STime <=", value, "createdStime");
            return (Criteria) this;
        }

        public Criteria andCreatedStimeIn(List<Date> values) {
            addCriterion("Created_STime in", values, "createdStime");
            return (Criteria) this;
        }

        public Criteria andCreatedStimeNotIn(List<Date> values) {
            addCriterion("Created_STime not in", values, "createdStime");
            return (Criteria) this;
        }

        public Criteria andCreatedStimeBetween(Date value1, Date value2) {
            addCriterion("Created_STime between", value1, value2, "createdStime");
            return (Criteria) this;
        }

        public Criteria andCreatedStimeNotBetween(Date value1, Date value2) {
            addCriterion("Created_STime not between", value1, value2, "createdStime");
            return (Criteria) this;
        }

        public Criteria andModifiedStimeIsNull() {
            addCriterion("Modified_STime is null");
            return (Criteria) this;
        }

        public Criteria andModifiedStimeIsNotNull() {
            addCriterion("Modified_STime is not null");
            return (Criteria) this;
        }

        public Criteria andModifiedStimeEqualTo(Date value) {
            addCriterion("Modified_STime =", value, "modifiedStime");
            return (Criteria) this;
        }

        public Criteria andModifiedStimeNotEqualTo(Date value) {
            addCriterion("Modified_STime <>", value, "modifiedStime");
            return (Criteria) this;
        }

        public Criteria andModifiedStimeGreaterThan(Date value) {
            addCriterion("Modified_STime >", value, "modifiedStime");
            return (Criteria) this;
        }

        public Criteria andModifiedStimeGreaterThanOrEqualTo(Date value) {
            addCriterion("Modified_STime >=", value, "modifiedStime");
            return (Criteria) this;
        }

        public Criteria andModifiedStimeLessThan(Date value) {
            addCriterion("Modified_STime <", value, "modifiedStime");
            return (Criteria) this;
        }

        public Criteria andModifiedStimeLessThanOrEqualTo(Date value) {
            addCriterion("Modified_STime <=", value, "modifiedStime");
            return (Criteria) this;
        }

        public Criteria andModifiedStimeIn(List<Date> values) {
            addCriterion("Modified_STime in", values, "modifiedStime");
            return (Criteria) this;
        }

        public Criteria andModifiedStimeNotIn(List<Date> values) {
            addCriterion("Modified_STime not in", values, "modifiedStime");
            return (Criteria) this;
        }

        public Criteria andModifiedStimeBetween(Date value1, Date value2) {
            addCriterion("Modified_STime between", value1, value2, "modifiedStime");
            return (Criteria) this;
        }

        public Criteria andModifiedStimeNotBetween(Date value1, Date value2) {
            addCriterion("Modified_STime not between", value1, value2, "modifiedStime");
            return (Criteria) this;
        }

        public Criteria andOrdernumLikeInsensitive(String value) {
            addCriterion("upper(ordernum) like", value.toUpperCase(), "ordernum");
            return (Criteria) this;
        }

        public Criteria andMemberIdLikeInsensitive(String value) {
            addCriterion("upper(member_id) like", value.toUpperCase(), "memberId");
            return (Criteria) this;
        }

        public Criteria andPskuIdLikeInsensitive(String value) {
            addCriterion("upper(psku_id) like", value.toUpperCase(), "pskuId");
            return (Criteria) this;
        }

        public Criteria andProdNameLikeInsensitive(String value) {
            addCriterion("upper(prod_name) like", value.toUpperCase(), "prodName");
            return (Criteria) this;
        }

        public Criteria andSellerNameLikeInsensitive(String value) {
            addCriterion("upper(seller_name) like", value.toUpperCase(), "sellerName");
            return (Criteria) this;
        }

        public Criteria andPlatformIdLikeInsensitive(String value) {
            addCriterion("upper(platform_id) like", value.toUpperCase(), "platformId");
            return (Criteria) this;
        }

        public Criteria andExtInfoLikeInsensitive(String value) {
            addCriterion("upper(ext_info) like", value.toUpperCase(), "extInfo");
            return (Criteria) this;
        }

        public Criteria andRecycleLikeInsensitive(String value) {
            addCriterion("upper(recycle) like", value.toUpperCase(), "recycle");
            return (Criteria) this;
        }

        public Criteria andSourceLikeInsensitive(String value) {
            addCriterion("upper(source) like", value.toUpperCase(), "source");
            return (Criteria) this;
        }

        public Criteria andBusinessIdLikeInsensitive(String value) {
            addCriterion("upper(business_id) like", value.toUpperCase(), "businessId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}